Defining a Crosstab Grid

Create a new grid from the General ribbon bar or using the Crosstab Grid reporting tool, and then configure the data you want to display in the grid by dragging the required columns from the Data Explorer, or using the configuration settings.

You can also configure more advanced settings by flipping the grid. The advanced settings include options to configure the grid's filter, columns, rows, measures, layout and Excel export settings.

Procedure

1. Create a new grid document:
   • On the General ribbon bar, select New > Crosstabulation Grid, or
   • Drag the Crosstab Grid reporting tool beneath an existing segment.
   • A new blank grid is added to the Workspace.
2. Drag a suitable column from the Data Explorer and drop it onto the grid area to create a simple grid. For example:

3. Click the Recalculate button.

The grid will display counts for that column, at the resolution of the table that the column was created from:

4. If required, add additional dimensions by dragging them from the Data Explorer and dropping on the grid.

• Crosstab Grid
  • Defining a Crosstab Grid
    • Grids and Configuration Settings
  • Grid Presentation Settings
  • Saving a Grid as a Template
  • Template Toolbar
  • Creating an Excel Template
  • Exporting to Excel